﻿if exists (select * from dbo.sysobjects where name = 'sp_Work_Update')	drop procedure [dbo].[sp_Work_Update]Go CREATE PROCEDURE dbo.sp_Work_Update	@woID		int,	@uID		int,	@Name		nvarchar(50),	@StartDate		datetime,	@EndDate		datetime,	@Date		datetime,	@Content		ntext,	@Detail		ntext,	@Status		nvarchar(50),	@Point		float,	@PointLD		float,	@PointLD_1		float,	@TotalPoint		floatAS	UPDATE [Work] SET [uID] = @uID, [Name] = @Name, [StartDate] = @StartDate, [EndDate] = @EndDate, [Date] = @Date, [Content] = @Content, [Detail] = @Detail, [Status] = @Status, [Point] = @Point, [PointLD] = @PointLD, [PointLD_1] = @PointLD_1, [TotalPoint] = @TotalPoint	 WHERE woID = @woIDGo 